Yes, he is real. I think God created him to blame all the evil He had done and will continue doing after the time of Satan's creation, sometime in the Persian period. Before Satan's birth, he was only an employee of God doing his will (Angel of Yahweh) with similar name.
Compare 1 Chronicles 21:1 (Satan's first and only evil act in the old testament) to 2 Samuel 24:1 (the real evil doer)
By the time of the new testament Satan had had a lot of practice and had become really good at evil doing. Today, pretty much every evil act is caused by Satan and every good act is done by God. But any discerning person knows that the buck stops with God because he created Satan.
Did I make any sense???